Unit 27 Spreadsheet Modelling

Spreadsheets can be used in many different situations, such as finance and engineering and the unit content
includes a wide range of spreadsheet features, formulae and functions. In addition, spreadsheet users need
to be able to choose from a variety of different ways of presenting and analysing spreadsheet data, including
producing graphs and filtering and sorting lists of data. Learners will be able to combine the skills developed to
produce a spreadsheet model that is tailor made for the specific needs of the user.

A spreadsheet can be used to store, manipulate and analyse data and to present it
in easy-to-understand formats, such as charts and graphs. Many people also use spreadsheets in preference
to word processing software when creating complex tables. Learners will investigate different ways of using
spreadsheets, find examples of real uses and develop the practical skills needed to use spreadsheet software
effectively.